Pandas Profiling Report

Dataset statistics

Number of variables	18
Number of observations	140446
Missing cells	784
Missing cells (%)	< 0.1%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	24.1 MiB
Average record size in memory	180.1 B

Variable types

DateTime	3
Categorical	8
Numeric	7

Alerts

`Carbon emissions estimate num` is highly overall correlated with `carbon_emission% num` and 1 other fields	High correlation
`Trip_Type` is highly overall correlated with `round_trip_duration`	High correlation
`carbon_emission% num` is highly overall correlated with `Carbon emissions estimate num`	High correlation
`carrier` is highly overall correlated with `overhead_bin`	High correlation
`flight_duration_value` is highly overall correlated with `layover_count`	High correlation
`layover_count` is highly overall correlated with `flight_duration_value`	High correlation
`overhead_bin` is highly overall correlated with `Carbon emissions estimate num` and 1 other fields	High correlation
`price` is highly overall correlated with `round_trip_duration`	High correlation
`round_trip_duration` is highly overall correlated with `Trip_Type` and 1 other fields	High correlation
`layover_count` is highly imbalanced (67.8%)	Imbalance
`Holiday` is highly imbalanced (86.0%)	Imbalance
`round_trip_duration` has 63316 (45.1%) zeros	Zeros

Reproduction

Analysis started	2024-07-25 23:43:02.675866
Analysis finished	2024-07-25 23:43:14.854316
Duration	12.18 seconds
Software version	ydata-profiling vv4.9.0
Download configuration	config.json

Report_Run_Time
Date

Distinct	27
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	6.2 MiB

Minimum	2024-03-10 00:00:00
Maximum	2024-04-06 00:00:00

Histogram

Histogram with fixed size bins (bins=27)

carrier
Categorical

HIGH CORRELATION

Distinct	9
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	6.2 MiB

JetBlue	36156
United	28364
American	26802
Delta	25562
Spirit	9560
Other values (4)	14002

Length

Max length	20
Median length	11
Mean length	6.6486906
Min length	5

Characters and Unicode

Total characters	933782
Distinct characters	28
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Spirit
2nd row	Alaska
3rd row	JetBlue
4th row	United
5th row	Spirit

Common Values

Value	Count	Frequency (%)
JetBlue	36156	25.7%
United	28364	20.2%
American	26802	19.1%
Delta	25562	18.2%
Spirit	9560	6.8%
Alaska	8255	5.9%
Third Party	4098	2.9%
Frontier	1389	1.0%
Sun Country Airlines	260	0.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
jetblue	36156	24.9%
united	28364	19.6%
american	26802	18.5%
delta	25562	17.6%
spirit	9560	6.6%
alaska	8255	5.7%
third	4098	2.8%
party	4098	2.8%
frontier	1389	1.0%
sun	260	0.2%
Other values (2)	520	0.4%

Most occurring characters

Value	Count	Frequency (%)
e	154689	16.6%
t	105389	11.3%
i	80293	8.6%
a	72972	7.8%
l	70233	7.5%
n	57335	6.1%
r	47856	5.1%
u	36676	3.9%
J	36156	3.9%
B	36156	3.9%
Other values (18)	236027	25.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	933782	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	154689	16.6%
t	105389	11.3%
i	80293	8.6%
a	72972	7.8%
l	70233	7.5%
n	57335	6.1%
r	47856	5.1%
u	36676	3.9%
J	36156	3.9%
B	36156	3.9%
Other values (18)	236027	25.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	933782	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	154689	16.6%
t	105389	11.3%
i	80293	8.6%
a	72972	7.8%
l	70233	7.5%
n	57335	6.1%
r	47856	5.1%
u	36676	3.9%
J	36156	3.9%
B	36156	3.9%
Other values (18)	236027	25.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	933782	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	154689	16.6%
t	105389	11.3%
i	80293	8.6%
a	72972	7.8%
l	70233	7.5%
n	57335	6.1%
r	47856	5.1%
u	36676	3.9%
J	36156	3.9%
B	36156	3.9%
Other values (18)	236027	25.3%

Trip_Type
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	6.2 MiB

Rounds Trip	77130
One Way	63316

Length

Max length	11
Median length	11
Mean length	9.1967162
Min length	7

Characters and Unicode

Total characters	1291642
Distinct characters	16
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Rounds Trip
2nd row	Rounds Trip
3rd row	Rounds Trip
4th row	Rounds Trip
5th row	Rounds Trip

Common Values

Value	Count	Frequency (%)
Rounds Trip	77130	54.9%
One Way	63316	45.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
rounds	77130	27.5%
trip	77130	27.5%
one	63316	22.5%
way	63316	22.5%

Most occurring characters

Value	Count	Frequency (%)
n	140446	10.9%
	140446	10.9%
R	77130	6.0%
o	77130	6.0%
u	77130	6.0%
d	77130	6.0%
s	77130	6.0%
T	77130	6.0%
r	77130	6.0%
i	77130	6.0%
Other values (6)	393710	30.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1291642	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
n	140446	10.9%
	140446	10.9%
R	77130	6.0%
o	77130	6.0%
u	77130	6.0%
d	77130	6.0%
s	77130	6.0%
T	77130	6.0%
r	77130	6.0%
i	77130	6.0%
Other values (6)	393710	30.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1291642	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
n	140446	10.9%
	140446	10.9%
R	77130	6.0%
o	77130	6.0%
u	77130	6.0%
d	77130	6.0%
s	77130	6.0%
T	77130	6.0%
r	77130	6.0%
i	77130	6.0%
Other values (6)	393710	30.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1291642	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
n	140446	10.9%
	140446	10.9%
R	77130	6.0%
o	77130	6.0%
u	77130	6.0%
d	77130	6.0%
s	77130	6.0%
T	77130	6.0%
r	77130	6.0%
i	77130	6.0%
Other values (6)	393710	30.5%

Airport_Route
Categorical

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	6.2 MiB

JFK - LAX	38780
LAX - JFK	35535
EWR - LAX	27505
LAX - EWR	27396
LAX - LGA	6315

Length

Max length	9
Median length	9
Mean length	9
Min length	9

Characters and Unicode

Total characters	1264014
Distinct characters	12
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	EWR - LAX
2nd row	EWR - LAX
3rd row	EWR - LAX
4th row	EWR - LAX
5th row	LGA - LAX

Common Values

Value	Count	Frequency (%)
JFK - LAX	38780	27.6%
LAX - JFK	35535	25.3%
EWR - LAX	27505	19.6%
LAX - EWR	27396	19.5%
LAX - LGA	6315	4.5%
LGA - LAX	4915	3.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
	140446	33.3%
lax	140446	33.3%
jfk	74315	17.6%
ewr	54901	13.0%
lga	11230	2.7%

Most occurring characters

Value	Count	Frequency (%)
	280892	22.2%
L	151676	12.0%
A	151676	12.0%
-	140446	11.1%
X	140446	11.1%
J	74315	5.9%
F	74315	5.9%
K	74315	5.9%
E	54901	4.3%
W	54901	4.3%
Other values (2)	66131	5.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1264014	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	280892	22.2%
L	151676	12.0%
A	151676	12.0%
-	140446	11.1%
X	140446	11.1%
J	74315	5.9%
F	74315	5.9%
K	74315	5.9%
E	54901	4.3%
W	54901	4.3%
Other values (2)	66131	5.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1264014	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	280892	22.2%
L	151676	12.0%
A	151676	12.0%
-	140446	11.1%
X	140446	11.1%
J	74315	5.9%
F	74315	5.9%
K	74315	5.9%
E	54901	4.3%
W	54901	4.3%
Other values (2)	66131	5.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1264014	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	280892	22.2%
L	151676	12.0%
A	151676	12.0%
-	140446	11.1%
X	140446	11.1%
J	74315	5.9%
F	74315	5.9%
K	74315	5.9%
E	54901	4.3%
W	54901	4.3%
Other values (2)	66131	5.2%

price
Real number (ℝ)

HIGH CORRELATION

Distinct	1018
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	354.64997

Minimum	46
Maximum	4074
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.2 MiB

Quantile statistics

Minimum	46
5-th percentile	134
Q1	229
median	329
Q3	452
95-th percentile	655
Maximum	4074
Range	4028
Interquartile range (IQR)	223

Descriptive statistics

Standard deviation	174.14629
Coefficient of variation (CV)	0.4910371
Kurtosis	41.231725
Mean	354.64997
Median Absolute Deviation (MAD)	109
Skewness	2.9817906
Sum	49809169
Variance	30326.93
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
204	2125	1.5%
229	2038	1.5%
244	2014	1.4%
274	1944	1.4%
254	1760	1.3%
259	1675	1.2%
319	1518	1.1%
309	1475	1.1%
178	1407	1.0%
374	1370	1.0%
Other values (1008)	123120	87.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
46	1	< 0.1%
47	1	< 0.1%
64	2	< 0.1%
65	2	< 0.1%
66	6	< 0.1%
71	13	< 0.1%
72	4	< 0.1%
73	7	< 0.1%
74	6	< 0.1%
75	1	< 0.1%

Value	Count	Frequency (%)
4074	1	< 0.1%
4042	1	< 0.1%
4039	4	< 0.1%
4029	1	< 0.1%
3990	1	< 0.1%
3945	4	< 0.1%
3915	2	< 0.1%
3910	3	< 0.1%
3884	1	< 0.1%
3829	1	< 0.1%

overhead_bin
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	6.2 MiB

Additional charge for overhead bin	75344
No additional charge for overhead bin	65102

Length

Max length	37
Median length	34
Mean length	35.390613
Min length	34

Characters and Unicode

Total characters	4970470
Distinct characters	18
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Additional charge for overhead bin
2nd row	No additional charge for overhead bin
3rd row	Additional charge for overhead bin
4th row	Additional charge for overhead bin
5th row	No additional charge for overhead bin

Common Values

Value	Count	Frequency (%)
Additional charge for overhead bin	75344	53.6%
No additional charge for overhead bin	65102	46.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
additional	140446	18.3%
charge	140446	18.3%
for	140446	18.3%
overhead	140446	18.3%
bin	140446	18.3%
no	65102	8.5%

Most occurring characters

Value	Count	Frequency (%)
	626886	12.6%
o	486440	9.8%
a	486440	9.8%
i	421338	8.5%
d	421338	8.5%
r	421338	8.5%
e	421338	8.5%
n	280892	5.7%
h	280892	5.7%
c	140446	2.8%
Other values (8)	983122	19.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	4970470	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	626886	12.6%
o	486440	9.8%
a	486440	9.8%
i	421338	8.5%
d	421338	8.5%
r	421338	8.5%
e	421338	8.5%
n	280892	5.7%
h	280892	5.7%
c	140446	2.8%
Other values (8)	983122	19.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	4970470	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	626886	12.6%
o	486440	9.8%
a	486440	9.8%
i	421338	8.5%
d	421338	8.5%
r	421338	8.5%
e	421338	8.5%
n	280892	5.7%
h	280892	5.7%
c	140446	2.8%
Other values (8)	983122	19.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	4970470	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	626886	12.6%
o	486440	9.8%
a	486440	9.8%
i	421338	8.5%
d	421338	8.5%
r	421338	8.5%
e	421338	8.5%
n	280892	5.7%
h	280892	5.7%
c	140446	2.8%
Other values (8)	983122	19.8%

layover_count
Categorical

HIGH CORRELATION IMBALANCE

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	6.2 MiB

0.0	121405
1.0	17004
2.0	1897
3.0	140

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	421338
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0.0
2nd row	0.0
3rd row	0.0
4th row	0.0
5th row	1.0

Common Values

Value	Count	Frequency (%)
0.0	121405	86.4%
1.0	17004	12.1%
2.0	1897	1.4%
3.0	140	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0.0	121405	86.4%
1.0	17004	12.1%
2.0	1897	1.4%
3.0	140	0.1%

Most occurring characters

Value	Count	Frequency (%)
0	261851	62.1%
.	140446	33.3%
1	17004	4.0%
2	1897	0.5%
3	140	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	421338	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	261851	62.1%
.	140446	33.3%
1	17004	4.0%
2	1897	0.5%
3	140	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	421338	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	261851	62.1%
.	140446	33.3%
1	17004	4.0%
2	1897	0.5%
3	140	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	421338	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	261851	62.1%
.	140446	33.3%
1	17004	4.0%
2	1897	0.5%
3	140	< 0.1%

round_trip_duration
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	91
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	24.913732

Minimum	0
Maximum	90
Zeros	63316
Zeros (%)	45.1%
Negative	0
Negative (%)	0.0%
Memory size	6.2 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	9
Q3	49
95-th percentile	83
Maximum	90
Range	90
Interquartile range (IQR)	49

Descriptive statistics

Standard deviation	29.697849
Coefficient of variation (CV)	1.1920273
Kurtosis	-0.84034394
Mean	24.913732
Median Absolute Deviation (MAD)	9
Skewness	0.79612442
Sum	3499034
Variance	881.96221
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	63316	45.1%
62	1405	1.0%
44	1346	1.0%
77	1246	0.9%
11	1246	0.9%
31	1238	0.9%
45	1236	0.9%
75	1194	0.9%
65	1181	0.8%
30	1176	0.8%
Other values (81)	65862	46.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	63316	45.1%
1	685	0.5%
2	861	0.6%
3	833	0.6%
4	745	0.5%
5	910	0.6%
6	869	0.6%
7	605	0.4%
8	1069	0.8%
9	871	0.6%

Value	Count	Frequency (%)
90	860	0.6%
89	813	0.6%
88	1133	0.8%
87	956	0.7%
86	725	0.5%
85	837	0.6%
84	999	0.7%
83	885	0.6%
82	880	0.6%
81	924	0.7%

Carbon emissions estimate num
Real number (ℝ)

HIGH CORRELATION

Distinct	305
Distinct (%)	0.2%
Missing	693
Missing (%)	0.5%
Infinite	0
Infinite (%)	0.0%
Mean	371.9604

Minimum	210
Maximum	984
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.3 MiB

Quantile statistics

Minimum	210
5-th percentile	250
Q1	297
median	381
Q3	411
95-th percentile	538
Maximum	984
Range	774
Interquartile range (IQR)	114

Descriptive statistics

Standard deviation	92.604006
Coefficient of variation (CV)	0.248962
Kurtosis	-0.31711541
Mean	371.9604
Median Absolute Deviation (MAD)	74
Skewness	0.59948433
Sum	51982582
Variance	8575.5019
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
411	6928	4.9%
390	5178	3.7%
381	4675	3.3%
538	4276	3.0%
529	3606	2.6%
402	3556	2.5%
301	3508	2.5%
548	3499	2.5%
537	3307	2.4%
392	3012	2.1%
Other values (295)	98208	69.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
210	174	0.1%
215	210	0.1%
236	270	0.2%
238	654	0.5%
239	711	0.5%
240	9	< 0.1%
241	513	0.4%
242	867	0.6%
244	162	0.1%
245	61	< 0.1%

Value	Count	Frequency (%)
984	2	< 0.1%
946	1	< 0.1%
835	10	< 0.1%
822	22	< 0.1%
817	47	< 0.1%
805	9	< 0.1%
803	1	< 0.1%
799	3	< 0.1%
716	1	< 0.1%
713	3	< 0.1%

carbon_emission% num
Real number (ℝ)

HIGH CORRELATION

Distinct	195
Distinct (%)	0.1%
Missing	91
Missing (%)	0.1%
Infinite	0
Infinite (%)	0.0%
Mean	112.98664

Minimum	59
Maximum	2522
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.3 MiB

Quantile statistics

Minimum	59
5-th percentile	70
Q1	84
median	107
Q3	115
95-th percentile	152
Maximum	2522
Range	2463
Interquartile range (IQR)	31

Descriptive statistics

Standard deviation	133.82932
Coefficient of variation (CV)	1.1844703
Kurtosis	219.71349
Mean	112.98664
Median Absolute Deviation (MAD)	21
Skewness	14.542021
Sum	15858240
Variance	17910.288
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
84	9760	6.9%
150	8084	5.8%
114	7601	5.4%
113	6992	5.0%
108	6437	4.6%
100	5933	4.2%
112	4391	3.1%
109	4207	3.0%
107	3665	2.6%
153	3555	2.5%
Other values (185)	79730	56.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
59	144	0.1%
60	240	0.2%
66	99	0.1%
67	1334	0.9%
68	1795	1.3%
69	1385	1.0%
70	2727	1.9%
71	3005	2.1%
72	3207	2.3%
73	2879	2.0%

Value	Count	Frequency (%)
2522	3	< 0.1%
2519	1	< 0.1%
2515	1	< 0.1%
2510	2	< 0.1%
2508	1	< 0.1%
2505	1	< 0.1%
2503	2	< 0.1%
2501	4	< 0.1%
2498	15	< 0.1%
2496	1	< 0.1%

Days_to_Fly
Real number (ℝ)

Distinct	90
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	45.499096

Minimum	1
Maximum	90
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.2 MiB

Quantile statistics

Minimum	1
5-th percentile	6
Q1	24
median	45
Q3	67
95-th percentile	86
Maximum	90
Range	89
Interquartile range (IQR)	43

Descriptive statistics

Standard deviation	25.606896
Coefficient of variation (CV)	0.56280011
Kurtosis	-1.1623426
Mean	45.499096
Median Absolute Deviation (MAD)	22
Skewness	0.015860365
Sum	6390166
Variance	655.71312
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
45	2012	1.4%
44	1961	1.4%
14	1904	1.4%
35	1892	1.3%
52	1886	1.3%
39	1873	1.3%
16	1865	1.3%
51	1841	1.3%
87	1836	1.3%
59	1826	1.3%
Other values (80)	121550	86.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1306	0.9%
2	1147	0.8%
3	1392	1.0%
4	1613	1.1%
5	1496	1.1%
6	1329	0.9%
7	1684	1.2%
8	1319	0.9%
9	1822	1.3%
10	1512	1.1%

Value	Count	Frequency (%)
90	1527	1.1%
89	1812	1.3%
88	1106	0.8%
87	1836	1.3%
86	1756	1.3%
85	1232	0.9%
84	1323	0.9%
83	1565	1.1%
82	1657	1.2%
81	1504	1.1%

from_timestamp_1
Date

Distinct	12315
Distinct (%)	8.8%
Missing	0
Missing (%)	0.0%
Memory size	6.2 MiB

Minimum	2024-03-12 05:01:00
Maximum	2024-07-05 21:40:00

Histogram

Histogram with fixed size bins (bins=50)

to_timestamp_1
Date

Distinct	16185
Distinct (%)	11.5%
Missing	0
Missing (%)	0.0%
Memory size	6.2 MiB

Minimum	2024-03-12 08:16:00
Maximum	2024-07-06 00:49:00

Histogram

Histogram with fixed size bins (bins=50)

from_hour_segment
Categorical

Distinct	8
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	6.2 MiB

3. 6 AM - 9 AM	35282
4. 9 AM - 12 PM	24125
8. 9 PM - 12 AM	23951
6. 3 PM - 6 PM	22353
5. 12 PM - 3 PM	18021
Other values (3)	16714

Length

Max length	15
Median length	14
Mean length	14.474481
Min length	14

Characters and Unicode

Total characters	2032883
Distinct characters	15
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	3. 6 AM - 9 AM
2nd row	3. 6 AM - 9 AM
3rd row	2. 3 AM - 6 AM
4th row	5. 12 PM - 3 PM
5th row	6. 3 PM - 6 PM

Common Values

Value	Count	Frequency (%)
3. 6 AM - 9 AM	35282	25.1%
4. 9 AM - 12 PM	24125	17.2%
8. 9 PM - 12 AM	23951	17.1%
6. 3 PM - 6 PM	22353	15.9%
5. 12 PM - 3 PM	18021	12.8%
7. 6 PM - 9 PM	14492	10.3%
2. 3 AM - 6 AM	1680	1.2%
1. 12 AM - 3 AM	542	0.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
pm	157808	18.7%
	140446	16.7%
am	123084	14.6%
9	97850	11.6%
6	96160	11.4%
3	77878	9.2%
12	66639	7.9%
4	24125	2.9%
8	23951	2.8%
5	18021	2.1%
Other values (3)	16714	2.0%

Most occurring characters

Value	Count	Frequency (%)
	702230	34.5%
M	280892	13.8%
P	157808	7.8%
.	140446	6.9%
-	140446	6.9%
A	123084	6.1%
9	97850	4.8%
6	96160	4.7%
3	77878	3.8%
2	68319	3.4%
Other values (5)	147770	7.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	2032883	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	702230	34.5%
M	280892	13.8%
P	157808	7.8%
.	140446	6.9%
-	140446	6.9%
A	123084	6.1%
9	97850	4.8%
6	96160	4.7%
3	77878	3.8%
2	68319	3.4%
Other values (5)	147770	7.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	2032883	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	702230	34.5%
M	280892	13.8%
P	157808	7.8%
.	140446	6.9%
-	140446	6.9%
A	123084	6.1%
9	97850	4.8%
6	96160	4.7%
3	77878	3.8%
2	68319	3.4%
Other values (5)	147770	7.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	2032883	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	702230	34.5%
M	280892	13.8%
P	157808	7.8%
.	140446	6.9%
-	140446	6.9%
A	123084	6.1%
9	97850	4.8%
6	96160	4.7%
3	77878	3.8%
2	68319	3.4%
Other values (5)	147770	7.3%

to_hour_segment
Categorical

Distinct	8
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	6.2 MiB

7. 6 PM - 9 PM	30222
8. 9 PM - 12 AM	26854
4. 9 AM - 12 PM	21831
6. 3 PM - 6 PM	18310
5. 12 PM - 3 PM	15268
Other values (3)	27961

Length

Max length	15
Median length	15
Mean length	14.517743
Min length	14

Characters and Unicode

Total characters	2038959
Distinct characters	15
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	4. 9 AM - 12 PM
2nd row	4. 9 AM - 12 PM
3rd row	3. 6 AM - 9 AM
4th row	6. 3 PM - 6 PM
5th row	6. 3 PM - 6 PM

Common Values

Value	Count	Frequency (%)
7. 6 PM - 9 PM	30222	21.5%
8. 9 PM - 12 AM	26854	19.1%
4. 9 AM - 12 PM	21831	15.5%
6. 3 PM - 6 PM	18310	13.0%
5. 12 PM - 3 PM	15268	10.9%
3. 6 AM - 9 AM	12908	9.2%
1. 12 AM - 3 AM	8762	6.2%
2. 3 AM - 6 AM	6291	4.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
pm	176285	20.9%
	140446	16.7%
am	104607	12.4%
9	91815	10.9%
6	86041	10.2%
12	72715	8.6%
3	61539	7.3%
7	30222	3.6%
8	26854	3.2%
4	21831	2.6%
Other values (3)	30321	3.6%

Most occurring characters

Value	Count	Frequency (%)
	702230	34.4%
M	280892	13.8%
P	176285	8.6%
.	140446	6.9%
-	140446	6.9%
A	104607	5.1%
9	91815	4.5%
6	86041	4.2%
1	81477	4.0%
2	79006	3.9%
Other values (5)	155714	7.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	2038959	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	702230	34.4%
M	280892	13.8%
P	176285	8.6%
.	140446	6.9%
-	140446	6.9%
A	104607	5.1%
9	91815	4.5%
6	86041	4.2%
1	81477	4.0%
2	79006	3.9%
Other values (5)	155714	7.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	2038959	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	702230	34.4%
M	280892	13.8%
P	176285	8.6%
.	140446	6.9%
-	140446	6.9%
A	104607	5.1%
9	91815	4.5%
6	86041	4.2%
1	81477	4.0%
2	79006	3.9%
Other values (5)	155714	7.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	2038959	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	702230	34.4%
M	280892	13.8%
P	176285	8.6%
.	140446	6.9%
-	140446	6.9%
A	104607	5.1%
9	91815	4.5%
6	86041	4.2%
1	81477	4.0%
2	79006	3.9%
Other values (5)	155714	7.6%

flight_duration_value
Real number (ℝ)

HIGH CORRELATION

Distinct	313
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.5613688

Minimum	2.5
Maximum	46.9
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.2 MiB

Quantile statistics

Minimum	2.5
5-th percentile	5.3
Q1	5.5
median	6
Q3	6.3
95-th percentile	10.5
Maximum	46.9
Range	44.4
Interquartile range (IQR)	0.8

Descriptive statistics

Standard deviation	2.7717993
Coefficient of variation (CV)	0.42244223
Kurtosis	41.818693
Mean	6.5613688
Median Absolute Deviation (MAD)	0.4
Skewness	5.6967575
Sum	921518
Variance	7.6828712
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
5.5	17245	12.3%
6.2	15646	11.1%
5.6	13884	9.9%
5.4	12767	9.1%
6	11455	8.2%
6.1	10509	7.5%
5.3	7052	5.0%
6.4	6563	4.7%
6.3	6019	4.3%
5.9	5285	3.8%
Other values (303)	34021	24.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2.5	1	< 0.1%
3.8	1	< 0.1%
4.7	2	< 0.1%
4.9	155	0.1%
5	245	0.2%
5.1	1564	1.1%
5.2	3406	2.4%
5.3	7052	5.0%
5.4	12767	9.1%
5.5	17245	12.3%

Value	Count	Frequency (%)
46.9	1	< 0.1%
43.5	4	< 0.1%
43.4	1	< 0.1%
42.7	1	< 0.1%
41.5	1	< 0.1%
41.2	2	< 0.1%
41	2	< 0.1%
40.9	6	< 0.1%
40.7	1	< 0.1%
40.3	2	< 0.1%

Holiday
Categorical

IMBALANCE

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	6.2 MiB

Not_Holiday	137678
Holiday	2768

Length

Max length	11
Median length	11
Mean length	10.921165
Min length	7

Characters and Unicode

Total characters	1533834
Distinct characters	10
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Not_Holiday
2nd row	Not_Holiday
3rd row	Not_Holiday
4th row	Not_Holiday
5th row	Not_Holiday

Common Values

Value	Count	Frequency (%)
Not_Holiday	137678	98.0%
Holiday	2768	2.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
not_holiday	137678	98.0%
holiday	2768	2.0%

Most occurring characters

Value	Count	Frequency (%)
o	278124	18.1%
H	140446	9.2%
l	140446	9.2%
i	140446	9.2%
d	140446	9.2%
a	140446	9.2%
y	140446	9.2%
N	137678	9.0%
t	137678	9.0%
_	137678	9.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1533834	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
o	278124	18.1%
H	140446	9.2%
l	140446	9.2%
i	140446	9.2%
d	140446	9.2%
a	140446	9.2%
y	140446	9.2%
N	137678	9.0%
t	137678	9.0%
_	137678	9.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1533834	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
o	278124	18.1%
H	140446	9.2%
l	140446	9.2%
i	140446	9.2%
d	140446	9.2%
a	140446	9.2%
y	140446	9.2%
N	137678	9.0%
t	137678	9.0%
_	137678	9.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1533834	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
o	278124	18.1%
H	140446	9.2%
l	140446	9.2%
i	140446	9.2%
d	140446	9.2%
a	140446	9.2%
y	140446	9.2%
N	137678	9.0%
t	137678	9.0%
_	137678	9.0%

Fly_WeekDay
Real number (ℝ)

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.9506358

Minimum	1
Maximum	7
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.6 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	4
Q3	6
95-th percentile	7
Maximum	7
Range	6
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	1.9875377
Coefficient of variation (CV)	0.50309313
Kurtosis	-1.2089114
Mean	3.9506358
Median Absolute Deviation (MAD)	2
Skewness	0.027130222
Sum	554851
Variance	3.9503062
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
4	21934	15.6%
1	21058	15.0%
5	20776	14.8%
3	19939	14.2%
7	19590	13.9%
2	19416	13.8%
6	17733	12.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	21058	15.0%
2	19416	13.8%
3	19939	14.2%
4	21934	15.6%
5	20776	14.8%
6	17733	12.6%
7	19590	13.9%

Value	Count	Frequency (%)
7	19590	13.9%
6	17733	12.6%
5	20776	14.8%
4	21934	15.6%
3	19939	14.2%
2	19416	13.8%
1	21058	15.0%

Auto

Heatmap
Table

	Airport_Route	Carbon emissions estimate num	Days_to_Fly	Fly_WeekDay	Holiday	Trip_Type	carbon_emission% num	carrier	flight_duration_value	from_hour_segment	layover_count	overhead_bin	price	round_trip_duration	to_hour_segment
Airport_Route	1.000	0.225	0.034	0.036	0.009	0.102	0.147	0.449	0.354	0.237	0.434	0.405	0.127	0.045	0.277
Carbon emissions estimate num	0.225	1.000	-0.102	0.007	0.006	0.078	0.995	0.453	0.036	0.093	0.208	0.698	0.140	0.026	0.096
Days_to_Fly	0.034	-0.102	1.000	0.001	0.156	0.042	-0.119	0.037	-0.038	0.031	0.065	0.065	-0.003	-0.001	0.021
Fly_WeekDay	0.036	0.007	0.001	1.000	0.218	0.049	0.007	0.037	-0.024	0.036	0.037	0.048	0.113	0.028	0.030
Holiday	0.009	0.006	0.156	0.218	1.000	0.024	0.007	0.012	0.012	0.010	0.008	0.003	0.017	0.045	0.008
Trip_Type	0.102	0.078	0.042	0.049	0.024	1.000	0.018	0.087	0.061	0.054	0.060	0.070	0.493	0.899	0.055
carbon_emission% num	0.147	0.995	-0.119	0.007	0.007	0.018	1.000	0.184	0.003	0.076	0.099	0.061	0.136	0.028	0.067
carrier	0.449	0.453	0.037	0.037	0.012	0.087	0.184	1.000	0.275	0.118	0.417	0.946	0.099	0.027	0.131
flight_duration_value	0.354	0.036	-0.038	-0.024	0.012	0.061	0.003	0.275	1.000	0.102	0.658	0.094	-0.236	-0.053	0.087
from_hour_segment	0.237	0.093	0.031	0.036	0.010	0.054	0.076	0.118	0.102	1.000	0.140	0.105	0.048	0.020	0.485
layover_count	0.434	0.208	0.065	0.037	0.008	0.060	0.099	0.417	0.658	0.140	1.000	0.086	0.124	0.032	0.079
overhead_bin	0.405	0.698	0.065	0.048	0.003	0.070	0.061	0.946	0.094	0.105	0.086	1.000	0.231	0.063	0.099
price	0.127	0.140	-0.003	0.113	0.017	0.493	0.136	0.099	-0.236	0.048	0.124	0.231	1.000	0.595	0.052
round_trip_duration	0.045	0.026	-0.001	0.028	0.045	0.899	0.028	0.027	-0.053	0.020	0.032	0.063	0.595	1.000	0.020
to_hour_segment	0.277	0.096	0.021	0.030	0.008	0.055	0.067	0.131	0.087	0.485	0.079	0.099	0.052	0.020	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	Report_Run_Time	carrier	Trip_Type	Airport_Route	price	overhead_bin	layover_count	round_trip_duration	Carbon emissions estimate num	carbon_emission% num	Days_to_Fly	from_timestamp_1	to_timestamp_1	from_hour_segment	to_hour_segment	flight_duration_value	Holiday	Fly_WeekDay
0	2024-03-10	Spirit	Rounds Trip	EWR - LAX	211.0	Additional charge for overhead bin	0.0	89	293	82	18	2024-03-28 06:47:00	2024-03-28 10:15:00	3. 6 AM - 9 AM	4. 9 AM - 12 PM	6.5	Not_Holiday	4
1	2024-03-10	Alaska	Rounds Trip	EWR - LAX	297.0	No additional charge for overhead bin	0.0	89	272	76	18	2024-03-28 07:30:00	2024-03-28 10:48:00	3. 6 AM - 9 AM	4. 9 AM - 12 PM	6.3	Not_Holiday	4
2	2024-03-10	JetBlue	Rounds Trip	EWR - LAX	298.0	Additional charge for overhead bin	0.0	89	422	118	18	2024-03-28 05:15:00	2024-03-28 08:30:00	2. 3 AM - 6 AM	3. 6 AM - 9 AM	6.2	Not_Holiday	4
3	2024-03-10	United	Rounds Trip	EWR - LAX	302.0	Additional charge for overhead bin	0.0	89	427	119	18	2024-03-28 12:00:00	2024-03-28 15:24:00	5. 12 PM - 3 PM	6. 3 PM - 6 PM	6.4	Not_Holiday	4
4	2024-03-10	Spirit	Rounds Trip	LGA - LAX	269.0	No additional charge for overhead bin	1.0	89	338	94	18	2024-03-28 16:29:00	2024-03-28 17:00:00	6. 3 PM - 6 PM	6. 3 PM - 6 PM	27.5	Not_Holiday	4
5	2024-03-10	Third Party	Rounds Trip	EWR - LAX	270.0	Additional charge for overhead bin	1.0	89	295	82	18	2024-03-28 07:47:00	2024-03-28 12:54:00	3. 6 AM - 9 AM	5. 12 PM - 3 PM	8.1	Not_Holiday	4
6	2024-03-10	Third Party	Rounds Trip	LGA - LAX	285.0	Additional charge for overhead bin	2.0	89	317	88	18	2024-03-28 22:50:00	2024-03-29 11:03:00	8. 9 PM - 12 AM	4. 9 AM - 12 PM	15.2	Not_Holiday	4
7	2024-03-10	United	Rounds Trip	EWR - LAX	309.0	Additional charge for overhead bin	0.0	89	246	69	18	2024-03-28 07:00:00	2024-03-28 10:09:00	3. 6 AM - 9 AM	4. 9 AM - 12 PM	6.2	Not_Holiday	4
8	2024-03-10	United	Rounds Trip	EWR - LAX	311.0	Additional charge for overhead bin	1.0	89	410	114	18	2024-03-28 12:19:00	2024-03-28 17:28:00	5. 12 PM - 3 PM	6. 3 PM - 6 PM	8.2	Not_Holiday	4
9	2024-03-10	United	Rounds Trip	EWR - LAX	320.0	Additional charge for overhead bin	0.0	89	246	69	18	2024-03-28 08:25:00	2024-03-28 11:35:00	3. 6 AM - 9 AM	4. 9 AM - 12 PM	6.2	Not_Holiday	4

	Report_Run_Time	carrier	Trip_Type	Airport_Route	price	overhead_bin	Carbon emissions estimate num	carbon_emission% num	Days_to_Fly	from_timestamp_1	to_timestamp_1	from_hour_segment	to_hour_segment	flight_duration_value	Holiday	Fly_WeekDay
140469	2024-04-06	JetBlue	One Way	LAX - JFK	254.0	Additional charge for overhead bin	372	106	89	2024-07-04 05:55:00	2024-07-05 14:30:00	2. 3 AM - 6 AM	5. 12 PM - 3 PM	5.6	Holiday	4
140470	2024-04-06	JetBlue	One Way	LAX - JFK	254.0	Additional charge for overhead bin	372	106	89	2024-07-04 07:00:00	2024-07-05 15:41:00	3. 6 AM - 9 AM	6. 3 PM - 6 PM	5.7	Holiday	4
140471	2024-04-06	JetBlue	One Way	LAX - JFK	254.0	Additional charge for overhead bin	372	106	89	2024-07-04 08:00:00	2024-07-05 16:34:00	3. 6 AM - 9 AM	6. 3 PM - 6 PM	5.6	Holiday	4
140472	2024-04-06	JetBlue	One Way	LAX - JFK	254.0	Additional charge for overhead bin	372	106	89	2024-07-04 23:42:00	2024-07-05 08:15:00	8. 9 PM - 12 AM	3. 6 AM - 9 AM	5.6	Holiday	4
140473	2024-04-06	Alaska	One Way	LAX - EWR	259.0	No additional charge for overhead bin	300	85	89	2024-07-04 08:10:00	2024-07-05 16:49:00	3. 6 AM - 9 AM	6. 3 PM - 6 PM	5.6	Holiday	4
140474	2024-04-06	Alaska	One Way	LAX - EWR	259.0	No additional charge for overhead bin	300	85	89	2024-07-04 10:20:00	2024-07-05 18:59:00	4. 9 AM - 12 PM	7. 6 PM - 9 PM	5.6	Holiday	4
140475	2024-04-06	JetBlue	One Way	LAX - EWR	259.0	Additional charge for overhead bin	370	100	89	2024-07-04 11:20:00	2024-07-05 19:49:00	4. 9 AM - 12 PM	7. 6 PM - 9 PM	5.5	Holiday	4
140476	2024-04-06	Delta	One Way	LAX - JFK	274.0	No additional charge for overhead bin	298	85	89	2024-07-04 06:00:00	2024-07-05 14:35:00	3. 6 AM - 9 AM	5. 12 PM - 3 PM	5.6	Holiday	4
140477	2024-04-06	Delta	One Way	LAX - JFK	274.0	No additional charge for overhead bin	298	85	89	2024-07-04 09:20:00	2024-07-05 18:15:00	4. 9 AM - 12 PM	7. 6 PM - 9 PM	5.9	Holiday	4
140478	2024-04-06	Delta	One Way	LAX - JFK	274.0	No additional charge for overhead bin	298	85	89	2024-07-04 16:00:00	2024-07-05 00:37:00	6. 3 PM - 6 PM	1. 12 AM - 3 AM	5.6	Holiday	4

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)